<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" interactivePageBreakByFrame="true" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-12-26. 17:19:56--><!--RSU-SPC-0093 The report specification was upgraded from &amp;amp;amp;quot;http://developer.cognos.com/schemas/report/8.0/&amp;amp;amp;quot; to &amp;amp;amp;quot;http://developer.cognos.com/schemas/report/11.0/&amp;amp;amp;quot; at 2015-7-25. 19:16:0--><!--RSU-SPC-0093 The report specification was upgraded from &amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;http://developer.cognos.com/schemas/report/8.0/&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot; to &amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;http://developer.cognos.com/schemas/report/11.0/&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot; at 2014-7-25. 17:58:34--><!--RSU-SPC-0093 The report specification was upgraded from &amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;http://developer.cognos.com/schemas/report/8.0/&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot; to &amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;http://developer.cognos.com/schemas/report/11.0/&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot; at 2014-7-25. 17:26:29--><!--RSU-SPC-0093 The report specification was upgraded from &amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;http://developer.cognos.com/schemas/report/8.0/&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot; to &amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;http://developer.cognos.com/schemas/report/11.0/&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot; at 2014-7-25. 11:50:41-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Chargeback']/model[@name='model']</modelPath>
				<drillBehavior/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles><CSS value="width:1024px"/></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles><CSS value="background-color:white"/></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;padding-left:24px;background-color:#6198C5"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Consolidated Chargeback</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:24px;color:#333333"/></style></textItem></contents><style><CSS value="height:36px;background-color:#FBFBFB;padding-left:24px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:1024px"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="height:15px"/></style></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;height:313px"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;height:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Chargeback</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:16px;font-weight:bold;color:rgb(162,158,158)"/></style></textItem></contents><style><CSS value="width:100%;padding-top:5px;padding-bottom:5px;padding-left:5px;height:5%;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Top Tenants</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:12px;font-weight:bold;color:rgb(162,158,158)"/></style></textItem></contents><style><CSS value="width:100%;padding-top:10px;padding-bottom:5px;padding-left:5px;height:5%;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><list horizontalPagination="true" name="List1" refQuery="Tenant Total">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%;font-family:Arial;font-size:12px;color:#333333;height:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none"/></style><contents/></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Tenant"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none"/></style><contents/></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2"/><dataFormat><currencyFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Allocated Cost"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents><style><CSS value="width:100%;padding-top:5px;padding-bottom:5px;padding-left:5px;height:90%"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="width:248px"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents/><style><CSS value="border-left:1px solid #E1E1E2"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;height:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Chargeback</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:16px;font-weight:bold;color:rgb(162,158,158)"/></style></textItem></contents><style><CSS value="width:100%;padding-top:5px;padding-bottom:5px;height:5%;text-align:left;padding-left:5px;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Top Line of Businesses</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:12px;font-weight:bold;color:rgb(162,158,158)"/></style></textItem></contents><style><CSS value="width:100%;padding-top:10px;padding-bottom:5px;padding-left:5px;height:5%;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><list horizontalPagination="true" name="List3" refQuery="Line of Business Total">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%;font-family:Arial;font-size:12px;color:#333333;height:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none"/></style><contents/></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Line of Business"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none"/></style><contents/></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2"/><dataFormat><currencyFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Allocated Cost"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents><style><CSS value="width:100%;padding-top:5px;padding-bottom:5px;padding-left:5px;height:90%"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="width:248px"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents/><style><CSS value="border-left:1px solid #E1E1E2"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;height:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Chargeback</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:16px;font-weight:bold;color:rgb(162,158,158)"/></style></textItem></contents><style><CSS value="width:100%;padding-top:5px;padding-bottom:5px;padding-left:5px;height:5%;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Top Business Units</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:12px;font-weight:bold;color:rgb(162,158,158)"/></style></textItem></contents><style><CSS value="width:100%;padding-top:10px;padding-bottom:5px;padding-left:5px;height:5%;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><list horizontalPagination="true" name="List5" refQuery="Business Unit Total">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%;height:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none"/></style><contents/></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Business Unit"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none"/></style><contents/></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2"/><dataFormat><currencyFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Allocated Cost"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents><style><CSS value="width:100%;padding-top:5px;padding-bottom:5px;padding-left:5px;height:90%"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="width:248px"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents/><style><CSS value="border-left:1px solid #E1E1E2"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;height:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Chargeback</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:16px;font-weight:bold;color:rgb(162,158,158)"/></style></textItem></contents><style><CSS value="width:100%;padding-top:5px;padding-bottom:5px;padding-left:5px;height:5%;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Top Projects</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:12px;font-weight:bold;color:rgb(162,158,158)"/></style></textItem></contents><style><CSS value="width:100%;padding-top:10px;padding-bottom:5px;padding-left:5px;height:5%;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><list horizontalPagination="true" name="List6" refQuery="Project Total">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%;height:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none"/></style><contents/></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Project"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none"/></style><contents/></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2"/><dataFormat><currencyFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Allocated Cost"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents><style><CSS value="width:100%;padding-top:5px;padding-bottom:5px;padding-left:5px;height:90%"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="width:248px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:15px"/></style></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents><textItem><dataSource><staticValue>Chargeback by Business Unit and Application Details</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:16px;font-weight:bold;color:rgb(162,158,158)"/></style></textItem></contents><style><CSS value="padding-top:5px;padding-bottom:10px;padding-left:5px;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:10px"/></style></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents><block>
			<contents><list horizontalPagination="true" name="List2" refQuery="Chargeback Total" rowsPerPage="250">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%;height:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2;border-right:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Tenant"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Tenant"/></dataSource></textItem></contents><listColumnRowSpan refDataItem="Tenant"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2;border-right:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Line of Business"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Line of Business"/></dataSource></textItem></contents><listColumnRowSpan refDataItem="Line of Business"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2;border-right:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Business Unit"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Business Unit"/></dataSource></textItem></contents><listColumnRowSpan refDataItem="Business Unit"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2;border-right:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Project"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Project"/></dataSource></textItem></contents><listColumnRowSpan refDataItem="Project"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2;border-right:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Application"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Application"/></dataSource></textItem></contents><listColumnRowSpan refDataItem="Application"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2;border-right:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Server/VM Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Server/VM Name"/></dataSource></textItem></contents><listColumnRowSpan refDataItem="Server/VM Name"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2;border-right:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Tier"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Tier"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2;border-right:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Tier Cost/GB"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2"/><dataFormat><currencyFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Tier Cost/GB"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2;border-right:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Replication"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Replication"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2;border-right:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Allocated Capacity (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Allocated Capacity (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Allocated Cost"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:right;font-family:Arial;font-size:12px;color:#333333;border-bottom:1px solid #E1E1E2"/><dataFormat><currencyFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Allocated Cost"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><listGroups><listGroup refDataItem="Tenant"><listFooter><listRows><listRow><rowCells><rowCell colSpan="9"><contents><textItem><dataSource><dataItemValue refDataItem="Tenant"/></dataSource></textItem><textItem><dataSource><staticValue> - </staticValue></dataSource></textItem><textItem><dataSource><staticValue>Total</staticValue></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="of"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;background-color:silver;border:1px solid #E1E1E2"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Allocated Capacity (GB))"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:right;background-color:silver;border:1px solid #E1E1E2"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Allocated Cost)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><dataFormat><currencyFormat/></dataFormat><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:right;background-color:silver;border:1px solid #E1E1E2"/></style></rowCell></rowCells></listRow></listRows></listFooter></listGroup><listGroup refDataItem="Line of Business"><listFooter><listRows><listRow><rowCells><rowCell colSpan="8"><contents><textItem><dataSource><dataItemValue refDataItem="Line of Business"/></dataSource></textItem><textItem><dataSource><staticValue> - </staticValue></dataSource></textItem><textItem><dataSource><staticValue>Total</staticValue></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="of"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;background-color:silver;border:1px solid #E1E1E2"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Allocated Capacity (GB))"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:right;background-color:silver;border:1px solid #E1E1E2"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Allocated Cost)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><dataFormat><currencyFormat/></dataFormat><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:right;background-color:silver;border:1px solid #E1E1E2"/></style></rowCell></rowCells></listRow></listRows></listFooter></listGroup><listGroup refDataItem="Business Unit"><listFooter><listRows><listRow><rowCells><rowCell colSpan="7"><contents><textItem><dataSource><dataItemValue refDataItem="Business Unit"/></dataSource></textItem><textItem><dataSource><staticValue> - </staticValue></dataSource></textItem><textItem><dataSource><staticValue>Total</staticValue></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="of"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;background-color:silver;border:1px solid #E1E1E2"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Allocated Capacity (GB))"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:right;background-color:silver;border:1px solid #E1E1E2"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Allocated Cost)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><dataFormat><currencyFormat/></dataFormat><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:right;background-color:silver;border:1px solid #E1E1E2"/></style></rowCell></rowCells></listRow></listRows></listFooter></listGroup><listGroup refDataItem="Project"><listFooter><listRows><listRow><rowCells><rowCell colSpan="6"><contents><textItem><dataSource><dataItemValue refDataItem="Project"/></dataSource></textItem><textItem><dataSource><staticValue> - </staticValue></dataSource></textItem><textItem><dataSource><staticValue>Total</staticValue></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="of"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;background-color:silver;border:1px solid #E1E1E2"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Allocated Capacity (GB))"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:right;background-color:silver;border:1px solid #E1E1E2"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Allocated Cost)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><dataFormat><currencyFormat/></dataFormat><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:right;background-color:silver;border:1px solid #E1E1E2"/></style></rowCell></rowCells></listRow></listRows></listFooter></listGroup><listGroup refDataItem="Application"><listFooter><listRows><listRow><rowCells><rowCell colSpan="5"><contents><textItem><dataSource><dataItemValue refDataItem="Application"/></dataSource></textItem><textItem><dataSource><staticValue> - </staticValue></dataSource></textItem><textItem><dataSource><staticValue>Total</staticValue></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="of"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;background-color:silver;border:1px solid #E1E1E2"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Allocated Capacity (GB))"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:right;background-color:silver;border:1px solid #E1E1E2"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Allocated Cost)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><dataFormat><currencyFormat/></dataFormat><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:right;background-color:silver;border:1px solid #E1E1E2"/></style></rowCell></rowCells></listRow></listRows></listFooter></listGroup><listGroup refDataItem="Server/VM Name"/></listGroups><listOverallGroup><listFooter><listRows><listRow><rowCells><rowCell colSpan="9"><contents><textItem><dataSource><staticValue>Overall</staticValue></dataSource></textItem><textItem><dataSource><staticValue> - </staticValue></dataSource></textItem><textItem><dataSource><staticValue>Total</staticValue></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="if"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;background-color:silver;border:1px solid #E1E1E2"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Allocated Capacity (GB))"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="is"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:right;background-color:silver;border:1px solid #E1E1E2"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Allocated Cost)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="is"/></defaultStyles><dataFormat><currencyFormat/></dataFormat><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:right;background-color:silver;border:1px solid #E1E1E2"/></style></rowCell></rowCells></listRow></listRows></listFooter></listOverallGroup></list></contents>
		<style><CSS value="width:1024px;height:500px;overflow:auto"/></style></block></contents></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.905Z"/></XMLAttributes><reportName>5.5 Consolidated Chargeback</reportName><classStyles><classStyle name="ls"><CSS value="border-collapse:collapse"/></classStyle><classStyle name="lt"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-left-style:none;background-color:white;color:black;text-align:left;font-weight:bold;border-bottom:1.5pt solid black"/></classStyle><classStyle name="lc"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="lm"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="lh"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="lf"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="ih"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="if"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="is"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="oh"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="of"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="os"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle></classStyles><queries><query name="Chargeback Total">
			<source>
				
			<sqlQuery dataSource="dwh_capacity" name="SQL9" type="passThrough">
			<sqlText>SELECT 	dwh_capacity.business_entity_dimension.tenant AS 'Tenant',
	dwh_capacity.business_entity_dimension.lob AS 'Line of Business',
	dwh_capacity.business_entity_dimension.businessUnit AS 'Business Unit',
	dwh_capacity.business_entity_dimension.project AS 'Project',
	dwh_capacity.application_dimension.name AS 'Application',
	dwh_capacity.host_dimension.name AS 'Server/VM Name',
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	dwh_capacity.tier_dimension.name
		ELSE 	dwh_capacity.service_level_dimension.name 
	END 	AS Tier,
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	dwh_capacity.tier_dimension.cost
		ELSE	dwh_capacity.service_level_dimension.cost 
	END 	AS 'Tier Cost/GB',
	dwh_capacity.chargeback_fact.protectionType AS 'Replication',
	ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024, 2) AS 'Allocated Capacity (GB)',
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024 * dwh_capacity.tier_dimension.cost, 2) 
		ELSE	ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024 * dwh_capacity.service_level_dimension.cost, 2) 
	END 	AS 'Allocated Cost'
FROM 	dwh_capacity.chargeback_fact
JOIN  	dwh_capacity.business_entity_dimension
ON 	dwh_capacity.chargeback_fact.businessEntityTk = dwh_capacity.business_entity_dimension.tk
AND 	dwh_capacity.business_entity_dimension.tk &lt;&gt; 0
JOIN 	dwh_capacity.application_dimension
ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
JOIN 	dwh_capacity.host_dimension
ON 	dwh_capacity.chargeback_fact.hostTk = dwh_capacity.host_dimension.tk
AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
JOIN 	dwh_capacity.service_level_dimension
ON 	dwh_capacity.chargeback_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
JOIN 	dwh_capacity.tier_dimension
ON 	dwh_capacity.chargeback_fact.tierTk = dwh_capacity.tier_dimension.tk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.latest = 1
GROUP BY
	dwh_capacity.business_entity_dimension.tk,
	dwh_capacity.application_dimension.tk,
	dwh_capacity.host_dimension.tk,
	Tier,
	dwh_capacity.chargeback_fact.protectionType
UNION
SELECT 	dwh_capacity.business_entity_dimension.tenant AS 'Tenant',
	dwh_capacity.business_entity_dimension.lob AS 'Line of Business',
	dwh_capacity.business_entity_dimension.businessUnit AS 'Business Unit',
	dwh_Capacity.business_entity_dimension.project AS 'Project',
	dwh_capacity.application_dimension.name AS 'Application',
	dwh_capacity.vm_dimension.name AS 'Server/VM Name',
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	dwh_capacity.tier_dimension.name
		ELSE 	dwh_capacity.service_level_dimension.name 
	END 	AS Tier,
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	dwh_capacity.tier_dimension.cost
		ELSE	dwh_capacity.service_level_dimension.cost 
	END 	AS 'Tier Cost/GB',
	'N/A' AS 'Replication',
	ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024, 2) AS 'Allocated Capacity (GB)',
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024 * dwh_capacity.tier_dimension.cost, 2) 
		ELSE	ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024 * dwh_capacity.service_level_dimension.cost, 2) 
	END 	AS 'Allocated Cost'
FROM 	dwh_capacity.vm_capacity_fact
JOIN 	dwh_capacity.business_entity_dimension
ON 	dwh_capacity.vm_capacity_fact.businessEntityTk = dwh_capacity.business_entity_dimension.tk
AND 	dwh_capacity.business_entity_dimension.tk &lt;&gt; 0
JOIN 	dwh_capacity.application_dimension
ON 	dwh_capacity.vm_capacity_fact.applicationTk = dwh_capacity.application_dimension.tk
JOIN 	dwh_capacity.vm_dimension
ON 	dwh_capacity.vm_capacity_fact.vmTk = dwh_capacity.vm_dimension.tk
JOIN 	dwh_capacity.service_level_dimension
ON 	dwh_capacity.vm_capacity_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
JOIN 	dwh_capacity.tier_dimension
ON 	dwh_capacity.vm_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.latest = 1
GROUP BY
	dwh_capacity.business_entity_dimension.tk,
	dwh_capacity.application_dimension.tk,
	dwh_capacity.vm_dimension.tk,
	Tier</sqlText>
		<mdProjectedItems><mdProjectedItem name="Tenant"/><mdProjectedItem name="Line of Business"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Project"/><mdProjectedItem name="Application"/><mdProjectedItem name="Server/VM Name"/><mdProjectedItem name="Tier"/><mdProjectedItem name="Tier Cost/GB"/><mdProjectedItem name="Replication"/><mdProjectedItem name="Allocated Capacity (GB)"/><mdProjectedItem name="Allocated Cost"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Tenant"><expression>[SQL9].[Tenant]</expression></dataItem><dataItem name="Line of Business"><expression>[SQL9].[Line of Business]</expression></dataItem><dataItem name="Business Unit"><expression>[SQL9].[Business Unit]</expression></dataItem><dataItem name="Project"><expression>[SQL9].[Project]</expression></dataItem><dataItem name="Application"><expression>[SQL9].[Application]</expression></dataItem><dataItem name="Server/VM Name"><expression>[SQL9].[Server/VM Name]</expression></dataItem><dataItem name="Tier"><expression>[SQL9].[Tier]</expression></dataItem><dataItem name="Tier Cost/GB"><expression>[SQL9].[Tier Cost/GB]</expression></dataItem><dataItem name="Replication"><expression>[SQL9].[Replication]</expression></dataItem><dataItem name="Allocated Capacity (GB)"><expression>[SQL9].[Allocated Capacity (GB)]</expression></dataItem><dataItem name="Allocated Cost"><expression>[SQL9].[Allocated Cost]</expression></dataItem><dataItemListSummary aggregateMethod="total" name="Total(Allocated Capacity (GB))" refDataItem="Allocated Capacity (GB)"/><dataItemListSummary aggregateMethod="total" name="Total(Allocated Cost)" refDataItem="Allocated Cost"/></selection>
		</query><query name="Tenant Total">
			<source>
				
			<sqlQuery dataSource="dwh_capacity" name="SQL1" type="passThrough">
			<sqlText>SELECT 	x.Tenant,
	ROUND(SUM(x.allocatedCost), 0) AS 'Allocated Cost',
	ROUND(SUM(x.allocatedCost), 0) AS allCost,
	ROUND(SUM(x.allocatedCapacity), 0) AS allCapacity,
	ROUND(SUM(x.allocatedCapacity), 0) AS 'Allocated Capacity (GB)'
FROM
(
SELECT 	dwh_capacity.business_entity_dimension.tenant AS Tenant,
	dwh_capacity.business_entity_dimension.lob AS LOB,
	dwh_capacity.business_entity_dimension.businessUnit AS BusinessUnit,
	dwh_capacity.business_entity_dimension.project AS Project,
	dwh_capacity.application_dimension.name AS 'Application',
	dwh_capacity.host_dimension.name AS 'Server/VM Name',
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	dwh_capacity.tier_dimension.name
		ELSE 	dwh_capacity.service_level_dimension.name 
	END 	AS Tier,
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	dwh_capacity.tier_dimension.cost
		ELSE	dwh_capacity.service_level_dimension.cost 
	END 	AS tierCost,
	dwh_capacity.chargeback_fact.protectionType AS 'Replication',
	ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024, 2) AS allocatedCapacity,
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024 * dwh_capacity.tier_dimension.cost, 2) 
		ELSE	ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024 * dwh_capacity.service_level_dimension.cost, 2) 
	END 	AS allocatedCost
FROM 	dwh_capacity.chargeback_fact
JOIN  	dwh_capacity.business_entity_dimension
ON 	dwh_capacity.chargeback_fact.businessEntityTk = dwh_capacity.business_entity_dimension.tk
AND 	dwh_capacity.business_entity_dimension.tk &lt;&gt; 0
JOIN 	dwh_capacity.application_dimension
ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
JOIN 	dwh_capacity.host_dimension
ON 	dwh_capacity.chargeback_fact.hostTk = dwh_capacity.host_dimension.tk
AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
JOIN 	dwh_capacity.service_level_dimension
ON 	dwh_capacity.chargeback_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
JOIN 	dwh_capacity.tier_dimension
ON 	dwh_capacity.chargeback_fact.tierTk = dwh_capacity.tier_dimension.tk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.latest = 1
GROUP BY
	dwh_capacity.business_entity_dimension.tk,
	dwh_capacity.application_dimension.tk,
	dwh_capacity.host_dimension.tk,
	Tier,
	dwh_capacity.chargeback_fact.protectionType
UNION
SELECT 	dwh_capacity.business_entity_dimension.tenant AS Tenant,
	dwh_capacity.business_entity_dimension.lob AS LOB,
	dwh_capacity.business_entity_dimension.businessUnit AS BusinessUnit,
	dwh_Capacity.business_entity_dimension.project AS Project,
	dwh_capacity.application_dimension.name AS 'Application',
	dwh_capacity.vm_dimension.name AS 'Server/VM Name',
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	dwh_capacity.tier_dimension.name
		ELSE 	dwh_capacity.service_level_dimension.name 
	END 	AS Tier,
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	dwh_capacity.tier_dimension.cost
		ELSE	dwh_capacity.service_level_dimension.cost 
	END 	AS tierCost,
	'N/A' AS 'Replication',
	ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024, 2) AS allocatedCapacity,
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024 * dwh_capacity.tier_dimension.cost, 2) 
		ELSE	ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024 * dwh_capacity.service_level_dimension.cost, 2) 
	END 	AS allocatedCost
FROM 	dwh_capacity.vm_capacity_fact
JOIN 	dwh_capacity.business_entity_dimension
ON 	dwh_capacity.vm_capacity_fact.businessEntityTk = dwh_capacity.business_entity_dimension.tk
AND 	dwh_capacity.business_entity_dimension.tk &lt;&gt; 0
JOIN 	dwh_capacity.application_dimension
ON 	dwh_capacity.vm_capacity_fact.applicationTk = dwh_capacity.application_dimension.tk
JOIN 	dwh_capacity.vm_dimension
ON 	dwh_capacity.vm_capacity_fact.vmTk = dwh_capacity.vm_dimension.tk
JOIN 	dwh_capacity.service_level_dimension
ON 	dwh_capacity.vm_capacity_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
JOIN 	dwh_capacity.tier_dimension
ON 	dwh_capacity.vm_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.latest = 1
GROUP BY
	dwh_capacity.business_entity_dimension.tk,
	dwh_capacity.application_dimension.tk,
	dwh_capacity.vm_dimension.tk,
	Tier
	) X
GROUP BY
	x.Tenant
ORDER BY
	allCost DESC
LIMIT 10</sqlText>
		<mdProjectedItems><mdProjectedItem name="Tenant"/><mdProjectedItem name="Allocated Cost"/><mdProjectedItem name="allCost"/><mdProjectedItem name="allCapacity"/><mdProjectedItem name="Allocated Capacity (GB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Tenant"><expression>[SQL1].[Tenant]</expression></dataItem><dataItem name="Allocated Cost"><expression>[SQL1].[Allocated Cost]</expression></dataItem><dataItem name="allCost"><expression>[SQL1].[allCost]</expression></dataItem><dataItem name="allCapacity"><expression>[SQL1].[allCapacity]</expression></dataItem><dataItem name="Allocated Capacity (GB)"><expression>[SQL1].[Allocated Capacity (GB)]</expression></dataItem></selection>
		</query><query name="Line of Business Total">
			<source>
				
			<sqlQuery dataSource="dwh_capacity" name="SQL2" type="passThrough">
			<sqlText>SELECT 	x.LOB AS 'Line of Business',
	ROUND(SUM(x.allocatedCost), 0) AS 'Allocated Cost',
	ROUND(SUM(x.allocatedCost), 0) AS allCost,
	ROUND(SUM(x.allocatedCapacity), 0) AS allCapacity,
	ROUND(SUM(x.allocatedCapacity), 0) AS 'Allocated Capacity (GB)'
FROM
(
SELECT 	dwh_capacity.business_entity_dimension.tenant AS Tenant,
	dwh_capacity.business_entity_dimension.lob AS LOB,
	dwh_capacity.business_entity_dimension.businessUnit AS BusinessUnit,
	dwh_capacity.business_entity_dimension.project AS Project,
	dwh_capacity.application_dimension.name AS 'Application',
	dwh_capacity.host_dimension.name AS 'Server/VM Name',
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	dwh_capacity.tier_dimension.name
		ELSE 	dwh_capacity.service_level_dimension.name 
	END 	AS Tier,
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	dwh_capacity.tier_dimension.cost
		ELSE	dwh_capacity.service_level_dimension.cost 
	END 	AS tierCost,
	dwh_capacity.chargeback_fact.protectionType AS 'Replication',
	ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024, 2) AS allocatedCapacity,
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024 * dwh_capacity.tier_dimension.cost, 2) 
		ELSE	ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024 * dwh_capacity.service_level_dimension.cost, 2) 
	END 	AS allocatedCost
FROM 	dwh_capacity.chargeback_fact
JOIN  	dwh_capacity.business_entity_dimension
ON 	dwh_capacity.chargeback_fact.businessEntityTk = dwh_capacity.business_entity_dimension.tk
AND 	dwh_capacity.business_entity_dimension.tk &lt;&gt; 0
JOIN 	dwh_capacity.application_dimension
ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
JOIN 	dwh_capacity.host_dimension
ON 	dwh_capacity.chargeback_fact.hostTk = dwh_capacity.host_dimension.tk
AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
JOIN 	dwh_capacity.service_level_dimension
ON 	dwh_capacity.chargeback_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
JOIN 	dwh_capacity.tier_dimension
ON 	dwh_capacity.chargeback_fact.tierTk = dwh_capacity.tier_dimension.tk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.latest = 1
GROUP BY
	dwh_capacity.business_entity_dimension.tk,
	dwh_capacity.application_dimension.tk,
	dwh_capacity.host_dimension.tk,
	Tier,
	dwh_capacity.chargeback_fact.protectionType
UNION
SELECT 	dwh_capacity.business_entity_dimension.tenant AS Tenant,
	dwh_capacity.business_entity_dimension.lob AS LOB,
	dwh_capacity.business_entity_dimension.businessUnit AS BusinessUnit,
	dwh_Capacity.business_entity_dimension.project AS Project,
	dwh_capacity.application_dimension.name AS 'Application',
	dwh_capacity.vm_dimension.name AS 'Server/VM Name',
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	dwh_capacity.tier_dimension.name
		ELSE 	dwh_capacity.service_level_dimension.name 
	END 	AS Tier,
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	dwh_capacity.tier_dimension.cost
		ELSE	dwh_capacity.service_level_dimension.cost 
	END 	AS tierCost,
	'N/A' AS 'Replication',
	ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024, 2) AS allocatedCapacity,
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024 * dwh_capacity.tier_dimension.cost, 2) 
		ELSE	ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024 * dwh_capacity.service_level_dimension.cost, 2) 
	END 	AS allocatedCost
FROM 	dwh_capacity.vm_capacity_fact
JOIN 	dwh_capacity.business_entity_dimension
ON 	dwh_capacity.vm_capacity_fact.businessEntityTk = dwh_capacity.business_entity_dimension.tk
AND 	dwh_capacity.business_entity_dimension.tk &lt;&gt; 0
JOIN 	dwh_capacity.application_dimension
ON 	dwh_capacity.vm_capacity_fact.applicationTk = dwh_capacity.application_dimension.tk
JOIN 	dwh_capacity.vm_dimension
ON 	dwh_capacity.vm_capacity_fact.vmTk = dwh_capacity.vm_dimension.tk
JOIN 	dwh_capacity.service_level_dimension
ON 	dwh_capacity.vm_capacity_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
JOIN 	dwh_capacity.tier_dimension
ON 	dwh_capacity.vm_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.latest = 1
GROUP BY
	dwh_capacity.business_entity_dimension.tk,
	dwh_capacity.application_dimension.tk,
	dwh_capacity.vm_dimension.tk,
	Tier
	) X
GROUP BY
	x.LOB
ORDER BY
	allCost DESC
LIMIT 10</sqlText>
		<mdProjectedItems><mdProjectedItem name="Line of Business"/><mdProjectedItem name="Allocated Cost"/><mdProjectedItem name="allCost"/><mdProjectedItem name="allCapacity"/><mdProjectedItem name="Allocated Capacity (GB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Line of Business"><expression>[SQL2].[Line of Business]</expression></dataItem><dataItem name="Allocated Cost"><expression>[SQL2].[Allocated Cost]</expression></dataItem><dataItem name="allCost"><expression>[SQL2].[allCost]</expression></dataItem><dataItem name="allCapacity"><expression>[SQL2].[allCapacity]</expression></dataItem><dataItem name="Allocated Capacity (GB)"><expression>[SQL2].[Allocated Capacity (GB)]</expression></dataItem></selection>
		</query><query name="Business Unit Total">
			<source>
				
			<sqlQuery dataSource="dwh_capacity" name="SQL10" type="passThrough">
			<sqlText>SELECT 	x.BusinessUnit AS 'Business Unit',
	ROUND(SUM(x.allocatedCost), 0) AS 'Allocated Cost',
	ROUND(SUM(x.allocatedCost), 0) AS allCost,
	ROUND(SUM(x.allocatedCapacity), 0) AS allCapacity,
	ROUND(SUM(x.allocatedCapacity), 0) AS 'Allocated Capacity (GB)'
FROM
(
SELECT 	dwh_capacity.business_entity_dimension.tenant AS Tenant,
	dwh_capacity.business_entity_dimension.lob AS LOB,
	dwh_capacity.business_entity_dimension.businessUnit AS BusinessUnit,
	dwh_capacity.business_entity_dimension.project AS Project,
	dwh_capacity.application_dimension.name AS 'Application',
	dwh_capacity.host_dimension.name AS 'Server/VM Name',
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	dwh_capacity.tier_dimension.name
		ELSE 	dwh_capacity.service_level_dimension.name 
	END 	AS Tier,
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	dwh_capacity.tier_dimension.cost
		ELSE	dwh_capacity.service_level_dimension.cost 
	END 	AS tierCost,
	dwh_capacity.chargeback_fact.protectionType AS 'Replication',
	ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024, 2) AS allocatedCapacity,
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024 * dwh_capacity.tier_dimension.cost, 2) 
		ELSE	ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024 * dwh_capacity.service_level_dimension.cost, 2) 
	END 	AS allocatedCost
FROM 	dwh_capacity.chargeback_fact
JOIN  	dwh_capacity.business_entity_dimension
ON 	dwh_capacity.chargeback_fact.businessEntityTk = dwh_capacity.business_entity_dimension.tk
AND 	dwh_capacity.business_entity_dimension.tk &lt;&gt; 0
JOIN 	dwh_capacity.application_dimension
ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
JOIN 	dwh_capacity.host_dimension
ON 	dwh_capacity.chargeback_fact.hostTk = dwh_capacity.host_dimension.tk
AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
JOIN 	dwh_capacity.service_level_dimension
ON 	dwh_capacity.chargeback_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
JOIN 	dwh_capacity.tier_dimension
ON 	dwh_capacity.chargeback_fact.tierTk = dwh_capacity.tier_dimension.tk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.latest = 1
GROUP BY
	dwh_capacity.business_entity_dimension.tk,
	dwh_capacity.application_dimension.tk,
	dwh_capacity.host_dimension.tk,
	Tier,
	dwh_capacity.chargeback_fact.protectionType
UNION
SELECT 	dwh_capacity.business_entity_dimension.tenant AS Tenant,
	dwh_capacity.business_entity_dimension.lob AS LOB,
	dwh_capacity.business_entity_dimension.businessUnit AS BusinessUnit,
	dwh_Capacity.business_entity_dimension.project AS Project,
	dwh_capacity.application_dimension.name AS 'Application',
	dwh_capacity.vm_dimension.name AS 'Server/VM Name',
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	dwh_capacity.tier_dimension.name
		ELSE 	dwh_capacity.service_level_dimension.name 
	END 	AS Tier,
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	dwh_capacity.tier_dimension.cost
		ELSE	dwh_capacity.service_level_dimension.cost 
	END 	AS tierCost,
	'N/A' AS 'Replication',
	ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024, 2) AS allocatedCapacity,
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024 * dwh_capacity.tier_dimension.cost, 2) 
		ELSE	ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024 * dwh_capacity.service_level_dimension.cost, 2) 
	END 	AS allocatedCost
FROM 	dwh_capacity.vm_capacity_fact
JOIN 	dwh_capacity.business_entity_dimension
ON 	dwh_capacity.vm_capacity_fact.businessEntityTk = dwh_capacity.business_entity_dimension.tk
AND 	dwh_capacity.business_entity_dimension.tk &lt;&gt; 0
JOIN 	dwh_capacity.application_dimension
ON 	dwh_capacity.vm_capacity_fact.applicationTk = dwh_capacity.application_dimension.tk
JOIN 	dwh_capacity.vm_dimension
ON 	dwh_capacity.vm_capacity_fact.vmTk = dwh_capacity.vm_dimension.tk
JOIN 	dwh_capacity.service_level_dimension
ON 	dwh_capacity.vm_capacity_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
JOIN 	dwh_capacity.tier_dimension
ON 	dwh_capacity.vm_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.latest = 1
GROUP BY
	dwh_capacity.business_entity_dimension.tk,
	dwh_capacity.application_dimension.tk,
	dwh_capacity.vm_dimension.tk,
	Tier
	) X
GROUP BY
	x.BusinessUnit
ORDER BY
	allCost DESC
LIMIT 10</sqlText>
		<mdProjectedItems><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Allocated Cost"/><mdProjectedItem name="allCost"/><mdProjectedItem name="allCapacity"/><mdProjectedItem name="Allocated Capacity (GB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Business Unit"><expression>[SQL10].[Business Unit]</expression></dataItem><dataItem name="Allocated Cost"><expression>[SQL10].[Allocated Cost]</expression></dataItem><dataItem name="allCost"><expression>[SQL10].[allCost]</expression></dataItem><dataItem name="allCapacity"><expression>[SQL10].[allCapacity]</expression></dataItem><dataItem name="Allocated Capacity (GB)"><expression>[SQL10].[Allocated Capacity (GB)]</expression></dataItem></selection>
		</query><query name="Project Total">
			<source>
				
			<sqlQuery dataSource="dwh_capacity" name="SQL3" type="passThrough">
			<sqlText>SELECT 	x.Project AS 'Project',
	ROUND(SUM(x.allocatedCost), 0) AS 'Allocated Cost',
	ROUND(SUM(x.allocatedCost), 0) AS allCost,
	ROUND(SUM(x.allocatedCapacity), 0) AS allCapacity,
	ROUND(SUM(x.allocatedCapacity), 0) AS 'Allocated Capacity (GB)'
FROM
(
SELECT 	dwh_capacity.business_entity_dimension.tenant AS Tenant,
	dwh_capacity.business_entity_dimension.lob AS LOB,
	dwh_capacity.business_entity_dimension.businessUnit AS BusinessUnit,
	dwh_capacity.business_entity_dimension.project AS Project,
	dwh_capacity.application_dimension.name AS 'Application',
	dwh_capacity.host_dimension.name AS 'Server/VM Name',
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	dwh_capacity.tier_dimension.name
		ELSE 	dwh_capacity.service_level_dimension.name 
	END 	AS Tier,
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	dwh_capacity.tier_dimension.cost
		ELSE	dwh_capacity.service_level_dimension.cost 
	END 	AS tierCost,
	dwh_capacity.chargeback_fact.protectionType AS 'Replication',
	ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024, 2) AS allocatedCapacity,
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024 * dwh_capacity.tier_dimension.cost, 2) 
		ELSE	ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024 * dwh_capacity.service_level_dimension.cost, 2) 
	END 	AS allocatedCost
FROM 	dwh_capacity.chargeback_fact
JOIN  	dwh_capacity.business_entity_dimension
ON 	dwh_capacity.chargeback_fact.businessEntityTk = dwh_capacity.business_entity_dimension.tk
AND 	dwh_capacity.business_entity_dimension.tk &lt;&gt; 0
JOIN 	dwh_capacity.application_dimension
ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
JOIN 	dwh_capacity.host_dimension
ON 	dwh_capacity.chargeback_fact.hostTk = dwh_capacity.host_dimension.tk
AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
JOIN 	dwh_capacity.service_level_dimension
ON 	dwh_capacity.chargeback_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
JOIN 	dwh_capacity.tier_dimension
ON 	dwh_capacity.chargeback_fact.tierTk = dwh_capacity.tier_dimension.tk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.latest = 1
GROUP BY
	dwh_capacity.business_entity_dimension.tk,
	dwh_capacity.application_dimension.tk,
	dwh_capacity.host_dimension.tk,
	Tier,
	dwh_capacity.chargeback_fact.protectionType
UNION
SELECT 	dwh_capacity.business_entity_dimension.tenant AS Tenant,
	dwh_capacity.business_entity_dimension.lob AS LOB,
	dwh_capacity.business_entity_dimension.businessUnit AS BusinessUnit,
	dwh_Capacity.business_entity_dimension.project AS Project,
	dwh_capacity.application_dimension.name AS 'Application',
	dwh_capacity.vm_dimension.name AS 'Server/VM Name',
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	dwh_capacity.tier_dimension.name
		ELSE 	dwh_capacity.service_level_dimension.name 
	END 	AS Tier,
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	dwh_capacity.tier_dimension.cost
		ELSE	dwh_capacity.service_level_dimension.cost 
	END 	AS tierCost,
	'N/A' AS 'Replication',
	ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024, 2) AS allocatedCapacity,
	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
		THEN 	ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024 * dwh_capacity.tier_dimension.cost, 2) 
		ELSE	ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024 * dwh_capacity.service_level_dimension.cost, 2) 
	END 	AS allocatedCost
FROM 	dwh_capacity.vm_capacity_fact
JOIN 	dwh_capacity.business_entity_dimension
ON 	dwh_capacity.vm_capacity_fact.businessEntityTk = dwh_capacity.business_entity_dimension.tk
AND 	dwh_capacity.business_entity_dimension.tk &lt;&gt; 0
JOIN 	dwh_capacity.application_dimension
ON 	dwh_capacity.vm_capacity_fact.applicationTk = dwh_capacity.application_dimension.tk
JOIN 	dwh_capacity.vm_dimension
ON 	dwh_capacity.vm_capacity_fact.vmTk = dwh_capacity.vm_dimension.tk
JOIN 	dwh_capacity.service_level_dimension
ON 	dwh_capacity.vm_capacity_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
JOIN 	dwh_capacity.tier_dimension
ON 	dwh_capacity.vm_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.latest = 1
GROUP BY
	dwh_capacity.business_entity_dimension.tk,
	dwh_capacity.application_dimension.tk,
	dwh_capacity.vm_dimension.tk,
	Tier
	) X
GROUP BY
	x.Project
ORDER BY
	allCost DESC
LIMIT 10</sqlText>
		<mdProjectedItems><mdProjectedItem name="Project"/><mdProjectedItem name="Allocated Cost"/><mdProjectedItem name="allCost"/><mdProjectedItem name="allCapacity"/><mdProjectedItem name="Allocated Capacity (GB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Project"><expression>[SQL3].[Project]</expression></dataItem><dataItem name="Allocated Cost"><expression>[SQL3].[Allocated Cost]</expression></dataItem><dataItem name="allCost"><expression>[SQL3].[allCost]</expression></dataItem><dataItem name="allCapacity"><expression>[SQL3].[allCapacity]</expression></dataItem><dataItem name="Allocated Capacity (GB)"><expression>[SQL3].[Allocated Capacity (GB)]</expression></dataItem></selection>
		</query></queries></report>